View the book

Read Online
(3.6 M)PDF
EPUB
Kindle
Daisy
(50.5 K)Full Text
(1.6 M)DjVu

All Files: HTTP

Resources

Bookmark

Microsoft Excel 2003 Tips'N Tricks (February 18, 2008)

Author: Prophet Technologies Pty Ltd
Keywords: Microsoft Excel; Microsoft Excel 2003; Tips'N Tricks; spreadsheet
Publisher: Prophet Technologies Pty Ltd
Year: 2008
Language: English
Book contributor: Prophet Technologies Pty Ltd
Collection: opensource

Description

This work is a collection of tips and tricks that may make using Microsoft Excel 2003 a little easier and interesting to use. This work describes how to easily create a series of numbers, view all the formulas on a worksheet, highlight a cell based on special conditions, use conditional (IF) formulas, count cells that meet your criteria, sum cells that meet only your criteria, hide worksheets, lookup answer in another table, freeze headings, and colour code worksheet tabs.

Creative Commons license: Attribution-Noncommercial-Share Alike 2.5 Australia

Write a review
Downloaded 3,302 times Reviews
Average Rating:

Reviewer: David_R - - January 24, 2010
Subject: Still a useful document
A couple of useful tips in this book. I often email the book to friends at work.

Reviewer: BookplateMuseum.com - - May 16, 2008
Subject: I use the book and like it
Some of it I knew, some of it I didn't. A nice and easy reference.

Reviewer: CantCatchMe - - March 28, 2008
Subject: I used this to learn how to use the lookup function
I downloaded this book to work out how to use lookup tables. The book gave a step by step example of a simple lookup table. Once I knew how to do one I was then able to figure out how to solve my own problem.

Reviewer: Amber1981 - - March 5, 2008
Subject: Useful
Helpful for frequently needed/used formula's.
Instructions easy to follow.

Reviewer: Gerda - - February 28, 2008
Subject: Extremely interesting
It was colorful and I look forward to using the tips.

Reviewer: Framan - - February 24, 2008
Subject: A useful booklet for work
I have been passing this booklet around to my friends because I think it's really useful.

Reviewer: HarvieB - - February 20, 2008
Subject: A great guide with some things I didn't know
I downloaded this book and was plesantly suprised by how useful it is. As an everyday use of Excel there were, of course,a number of items I knew but then there were some things I never thought to ask.

Thanks for uploading this book.

Selected metadata

Identifier:	MicrosoftExcel2003TipsnTricks
Mediatype:	texts
Licenseurl:	http://creativecommons.org/licenses/by-nc-sa/2.5/au/
Identifier-access:	http://www.archive.org/details/MicrosoftExcel2003TipsnTricks
Identifier-ark:	ark:/13960/t79s1rf55
Filesxml:	Thu Aug 20 15:36:59 UTC 2009
Ppi:	600
Ocr:	ABBYY FineReader 8.0